Oracle APEX

Very fast database level applications
Applications where reports and forms are there
Getting data from various sources like cloud

APEX is very well fit for solving fast some day to day activities in every organization.

The most suitable case for Oracle Application Express is any application, web desktop or mobile, that only needs to store and manipulate data in Oracle Database, and be accessed online all the time.

Other than that, avoid Oracle Application Express (e.g., apps which rely heavily to Javascript functionality, apps to analyze Twitter data, apps which need to manipulate OS files, apps to create complex and static reports).

Oracle Application Express is good for easy and fast application and reports development. You can develop entire applications and you do not need another web server. However, you cannot access the source code of applications built in Oracle Application Express.

Oracle Application Express is great for small applications, where you have a few pages. You upload an excel file, create a interactive grid, create user authorization and everybody can work on this grid. You can develop an application in hours or a few days.

I think it's less appropriate when a customer has a lot of special front-end wishes. In this case, it would be better to start with Angular and generate the front-end all manually.

It is appropriate for database application development supporting data driven processes, online transaction processing, BI/reports/analytics ... for addressing about any business data processing need I can think of. Oracle Application Express is fantastic for creating beautiful rich user interfaces with support for all major browsers rendering well on a range of devices. It is less appropriate for applications requiring native low level access to device peripherals and is less appropriate for applications that must execute offline without network/internet connection to supporting application and database servers.

Oracle Application Express can essentially be used for any web application that needs to talk to an Oracle Database. Simple applications to view/edit data can be turned out in next to no time with the built-in reports allowing fine-grained control for the end user. It really shines when used for tasks such as dashboard management or basic manipulation of data, all of which can be done with next to no code.

For less standardized tasks, the architecture will allow the use of other web technologies. I have, for instance, incorporated Google Maps into Oracle Application Express in order to visually show data, such as the operating areas, for our consultants. Setting this up in the Application Express framework is relatively straightforward allowing me to concentrate on the heavy lifting in PL/SQL.

The only major area I've found that it isn't well suited in currently is outputting anything printable, typically requiring the use of some 3rd party hardware or Oracle BI (if money is no object). I have also run into issues when working with larger teams as it doesn't lend itself well to source control with all the pages being stored in the database itself.

Oracle Application Express is well suited if you have a big dataset which has to be visualized in a graphic manner or if you have to provide a good solution to create, edit or manipulate data by end-users in a web-application. It is also well suited if you need to create KPIs that might already be in place and they just have to be brought to the surface in the browser!

It is very good when you have an application like Forms and need additional functionality (features) that you can't have in forms (dashboards, predefined IR with charts). It's a good use of external sources (web sources, REST API) and ata visualization. I haven't tried it yet, but I don't know how it functions in complex pages (a lot of client controls, few hundred fields). For example, we have physician reports or discharge summaries, and nurse documentation about the care of a patient.

No matter where you live, you can build scalable, secure enterprise apps. If you want to work in the same workspace as your team, you will need an Internet connection.

It's well suited if you need to display (or enter/change) data from an Oracle database. If you (or your customer) think you definitely need a native app, then it is not a good fit. Creating a dashboard with different kinds of charts and KPI's is easy using APEX. If you need a real data-mining solution, then you better switch to Oracle Analytics. As APEX offers an easy interface for RESTful services, you can also create forms, reports, and charts upon any RESTful service that's available on the internet -- either within or outside your organization.

We have converted a lot of old SharePoint processes to Apex applications. We are developing new applications using this tool. Most of the applications are being utilized to transition old processes to make them more efficient. The worst part of the software is having to strictly follow the structure, we cannot put as many columns and items as we would like and we would enjoy that customization.

If you need an application linked to an Oracle database, use APEX.

I feel like this system works well for most lines of business. It may not work well for organizations that only have a few people, but it is great when your organization is larger and/or spread out across multiple states. It allows for team members to have networking in that aspect.

It is a nice and inexpensive tool, ideal to extend the functionality of the systems, and offer users good reports, graphics and easy-to-use applications, developed with speed and low maintenance cost. We don’t use it when we have to customize standard processes in our ERP, mainly because we are SOX compliant, and it is more difficult to us to prove our auditors that we respect and accomplish with all the validations and controls they demand.

We needed an app system pronto and so with our switch to Oracle it worked out perfectly for us. We had been developing our database systems beforehand and so we were ready for the roll out without having to add any additional time or stress. APEX would not be well suited to any company that is not wholly committed to Oracle, though.

If there is a time limit and more security is required one should go with it as it provides locking functionality to prevent a deadlock situation.

Well suited to data entry and reporting. great for replacing small departmental spreadsheet applications in very quick time - up and running in minutes but I've also been involved in large-scale projects with thousands of users so scalability isn't a problem. One of the best things is that users love using Apex applications - I was told today by a user that it doesn't feel like working when she uses my applications.

Automation scenario : Suppose there is a user group that maintains Excel or their daily cost data entry. There are 4 users who work on the cost Excel worksheet. It can be individual or a shared excel. Once the data entry is done the data need to be reported in a BI report and distributed. Excel data entry can have fat fingering or typo errors that can cause issues with a report. In this situation we can use APEX and design a form that the 4 users can access at the same time, we can track which user is making what changes and without any delay once the data is committed in the form it can be made available for BI reporting . For small to medium size organization APEX can be used as a low cost BI tool for reporting and forms need, as it is free with the Oracle license.